﻿<%@ Page Title="" Language="VB" MasterPageFile="MasterPage.master" AutoEventWireup="false" CodeFile="report.aspx.vb" Inherits="report" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
    <div style="width:960px; height:750px;margin:0 auto;">
<h1 style="color:black;text-align:center;">這是報告</h1>

    <div style="width:500px; height:100px;margin:0 auto;">
        
            搜尋類別<asp:DropDownList ID="DropDownList1" runat="server" style="Width:200px;">
                <asp:ListItem Value="2">檢查項目</asp:ListItem>
                <asp:ListItem Value="1">檢查時間</asp:ListItem>
            </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MedicareConnectionString %>" SelectCommand="SELECT [檢驗日期] FROM [View_ExamCalendar]"></asp:SqlDataSource>
            <asp:DropDownList ID="DropDownList2" runat="server" style="Width:100px;" DataSourceID="SqlDataSource3" DataTextField="檢驗項目" DataValueField="檢驗項目"></asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MedicareConnectionString %>" SelectCommand="SELECT [檢驗項目] FROM [View_ExamCalendar]"></asp:SqlDataSource>
        
    </div>
    <div style="width:500px; height:500px;margin:0 auto;">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="病患名稱" HeaderText="病患名稱" SortExpression="病患名稱" />
                <asp:BoundField DataField="檢驗項目" HeaderText="檢驗項目" SortExpression="檢驗項目" />
                <asp:BoundField DataField="檢驗日期" HeaderText="檢驗日期" SortExpression="檢驗日期" />
                <asp:BoundField DataField="狀態" HeaderText="狀態" SortExpression="狀態" />
                <asp:BoundField DataField="檢驗結果" HeaderText="檢驗結果" SortExpression="檢驗結果" />
                <asp:BoundField DataField="結果值" HeaderText="結果值" SortExpression="結果值" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MedicareConnectionString %>" SelectCommand="SELECT [病患名稱], [檢驗項目], [檢驗日期], [狀態], [檢驗結果], [結果值] FROM [View_ExamCalendar]"></asp:SqlDataSource>
    </div>

</div>
</asp:Content>

